UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+oVbJAmWagItvCQD7Y6h3l9URyfywUl8IJyeClmaHCU='
WHERE
key_id = '8d829d9fa5a69c5212df67ed0a929f31fadd1d29b7ac48e5400b7c3fb1aa71c6'
AND (
token = '+oVbJAmWagItvCQD7Y6h3l9URyfywUl8IJyeClmaHCU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)