UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iISL7exyOyKU0TykqTJk9nV1OWrA6ilHXl/i6JcxZw0='
WHERE
key_id = '1f423d8a79c28e2818cf19ed97f1e11d0756fc17a4a352a0e0e54298b8a5b11c'
AND (
token = 'iISL7exyOyKU0TykqTJk9nV1OWrA6ilHXl/i6JcxZw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)