UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BfLrfx5v5LRCuaevaSIaf1oElH/q0Ccr1IaCj46l1LU='
WHERE
key_id = 'a5c2e78568fed4468006d9ed125ad5b2ba1e6e8b57aab727ab6f3f1803f00e53'
AND (
token = 'BfLrfx5v5LRCuaevaSIaf1oElH/q0Ccr1IaCj46l1LU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)