UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GiWttUeb8hkGkscMqwGKLVpyGmRlncx298u3kEW+gcU='
WHERE
key_id = '2913e59f0a0b3060288b5efaa2b1236532b8c8b43d3e6cfceb83b8b8ba4990c8'
AND (
token = 'GiWttUeb8hkGkscMqwGKLVpyGmRlncx298u3kEW+gcU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)