UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qYWfY7iuzTZR1jh2kF4BmOk4iN6Q23sISh6m5cYwhgM='
WHERE
key_id = '347e51d0198102968a03884151ccb1c680ab33448ec9139f1aaffbb49fc9a8b8'
AND (
token = 'qYWfY7iuzTZR1jh2kF4BmOk4iN6Q23sISh6m5cYwhgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)