UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '99n/QTTpiFI95EfCnN2v8//ZQLQz8GAzcnnIxWur8Fk='
WHERE
key_id = 'ef3ab555fafbc3b568cba92811b8e9c4666f86ca2166fc0486a2821387b30f4a'
AND (
token = '99n/QTTpiFI95EfCnN2v8//ZQLQz8GAzcnnIxWur8Fk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)