UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1QwHYgBPyJIPG9sBgN5ESU1MdegqCLorEMWy8j7wxTE='
WHERE
key_id = '8f9d616486b9a4cbd4a96a39b3fa68ea055b6bde21b9ef0966f6e44709962d50'
AND (
token = '1QwHYgBPyJIPG9sBgN5ESU1MdegqCLorEMWy8j7wxTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)