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