UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zsi/J1AeyvdUD1ULSZ6pfr4Z6LhK4pDOu9jVDeinszU='
WHERE
key_id = '670c00e57d14764d75ccd48f0aeed89f5d0133a3081f893f75a76f84ae806e24'
AND (
token = 'zsi/J1AeyvdUD1ULSZ6pfr4Z6LhK4pDOu9jVDeinszU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)