UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FfCiJmIP2mdxjXY7agwabfGgYpAttdWN1S/YuvAHiFU='
WHERE
key_id = 'bfcd00e50779e95bf9148cc6271305a4dc35f68bd414016b6342a6cf587aebb2'
AND (
token = 'FfCiJmIP2mdxjXY7agwabfGgYpAttdWN1S/YuvAHiFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)