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