UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rXuSpnisxXwrEDXzg9vt1W5NUjHsIgW7GtrVfbDrWm4='
WHERE
key_id = 'a71a67a0c28b66908ab783667e0f373910229b0f077e539c97c53cb96c0c31ad'
AND (
token = 'rXuSpnisxXwrEDXzg9vt1W5NUjHsIgW7GtrVfbDrWm4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)