UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TrRy4wkZ3464xW124fCrCmAqiErCIINiBZ1fVyZBaGA='
WHERE
key_id = '8230f1fa42d315d8c4c916b919a280d09488d14137e529f1e322f1eca0744b13'
AND (
token = 'TrRy4wkZ3464xW124fCrCmAqiErCIINiBZ1fVyZBaGA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)