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