UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Hf4NUrYNjYEaePKCvURD9ECZLh8Zpx5Dghs2NWPJ7Xw='
WHERE
key_id = 'e345f90526f98273fcb850cc8233d2318293511f6feed881d349bfa06d608d8d'
AND (
token = 'Hf4NUrYNjYEaePKCvURD9ECZLh8Zpx5Dghs2NWPJ7Xw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)