UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EJwYVh1oZIKXVBY1fjSkHfVHcph5e+jjQlQDLLCDaRU='
WHERE
key_id = '78f090772224e131f7983812d658c06c3eed9d353a1fd8effa013dddf67c6942'
AND (
token = 'EJwYVh1oZIKXVBY1fjSkHfVHcph5e+jjQlQDLLCDaRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)