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