UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nx/tN5AnBuCEgUoJu6pyp82Bdcmj02l4AuJExDHkhew='
WHERE
key_id = '1246ac74e5a83eb3f77d8ebd609da35977f70cdf195c38e7ec5d1acb97e3a6a2'
AND (
token = 'nx/tN5AnBuCEgUoJu6pyp82Bdcmj02l4AuJExDHkhew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)