UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3gMWvaQNOg6a912e58rv/7FF4fnapWwjGbrD/X+gBuc='
WHERE
key_id = '9faea30a70525cd11e6f4bdf45c927f1f43fbea387bb8b99bafae80fedb2beb1'
AND (
token = '3gMWvaQNOg6a912e58rv/7FF4fnapWwjGbrD/X+gBuc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)