UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yHhBk38MVYQ6DMLTLwzozV+SD8sLL3tPwvXCR8yAML4='
WHERE
key_id = '3569f61e82234779d9c2dba3d2af30f22424705296773bf9a9d2c6ed33ee3bf5'
AND (
token = 'yHhBk38MVYQ6DMLTLwzozV+SD8sLL3tPwvXCR8yAML4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)