UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ms8T9aJ3XoQkt4MFDoGgOneMugrfnrOglOsTSuVQSYY='
WHERE
key_id = '5a1296921b240c272bd13aaf26c4e7ed6e26743ac207a1c24e1f91678e69af7b'
AND (
token = 'ms8T9aJ3XoQkt4MFDoGgOneMugrfnrOglOsTSuVQSYY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)