UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '79PtjZww93ONcA2gxZq87oXJz6vNE1PHtxHF9eKi7q8='
WHERE
key_id = '16f614287245cb073f81b1e15223f745da795ae5723c457c38fb43b875623732'
AND (
token = '79PtjZww93ONcA2gxZq87oXJz6vNE1PHtxHF9eKi7q8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)