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