UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'A77yGgsnRgCpXsJBvbAy3lsxNWjDO1znZzzU7a+Dk2Y='
WHERE
key_id = '2fe780d2b286021e3077fb0de9cd2c0041247305f316bfbc75a5bf866fa5598a'
AND (
token = 'A77yGgsnRgCpXsJBvbAy3lsxNWjDO1znZzzU7a+Dk2Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)