UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0GbO3X2ODhNzTKYr/fcn4gzkc3LKkbZc1Q20htR7xpI='
WHERE
key_id = '1e005787158f1ba782a118d7d8244464f23ba776b192383b875cf33af96b19fe'
AND (
token = '0GbO3X2ODhNzTKYr/fcn4gzkc3LKkbZc1Q20htR7xpI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)