UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPZ10bW6L86+ijxQiw8HR8ac1e3LG7be83U6k7R+Nc8='
WHERE
key_id = '823a4e18c58a3cdf828d04a89f8ea7bf312e193bc574a11711aee5ca35c0ff55'
AND (
token = 'LPZ10bW6L86+ijxQiw8HR8ac1e3LG7be83U6k7R+Nc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)