UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'h01p6eirowhlUKFoQqhRLAmrMH1CNZT/oG6RyO1h1BI='
WHERE
key_id = 'c21128c6e3400f62bd85e1e80a02cc2f6baa0517edd0b0fd879f714e1a0be27e'
AND (
token = 'h01p6eirowhlUKFoQqhRLAmrMH1CNZT/oG6RyO1h1BI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)