UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HGzARabVZk+JzfxJ12odKMPUIJChMP7aR/V0QdTwYv0='
WHERE
key_id = 'b9e84777f374e8345f7ef1273aeef843cbc05095dfd2cb258a28bbc6b423d8e4'
AND (
token = 'HGzARabVZk+JzfxJ12odKMPUIJChMP7aR/V0QdTwYv0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)