UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lQRdB7x1MeQHfqvvEJ6eLzpZxHoFVGJZJREXdX9JO7I='
WHERE
key_id = '9705df99c43c620182e34bea4926b09bce0908bd935bdd6c52c8e3396989b9b4'
AND (
token = 'lQRdB7x1MeQHfqvvEJ6eLzpZxHoFVGJZJREXdX9JO7I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)