UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zSNTZhRKOIZPq3B6QkVX25Ah+StBzEfuteYh8/DkcP4='
WHERE
key_id = '27bd75d1ca7077b95d1d5efd265bd693a7e4774248e3a181ceb93a2de9394074'
AND (
token = 'zSNTZhRKOIZPq3B6QkVX25Ah+StBzEfuteYh8/DkcP4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)