UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XNzbbptfy40hpKhWgurhmqozZI3Sg1Js+t0+KsQ6zO0='
WHERE
key_id = '8de7919915d98ad1c90e170cb1e22a1732b16ea537fc431bb2f279b2795d8dcc'
AND (
token = 'XNzbbptfy40hpKhWgurhmqozZI3Sg1Js+t0+KsQ6zO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)