UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1cN3W2bcz+OpCbvhdWiO/QZAEgJ7pixaYiGi8Ut3nDk='
WHERE
key_id = '58569c0a3759bec09e8e256b6bdb8e1e9213e8e66f6f1ad017a84fde50ae6b18'
AND (
token = '1cN3W2bcz+OpCbvhdWiO/QZAEgJ7pixaYiGi8Ut3nDk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)