UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H2WGOVmtj9FOdbeR97D6NkimrjI3reIx+/3U4hFuywI='
WHERE
key_id = 'c288cdc3adb3490f1635f8411436788ae3be16994e501ebd6afa886497dc9a72'
AND (
token = 'H2WGOVmtj9FOdbeR97D6NkimrjI3reIx+/3U4hFuywI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)