UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5mxKFRD0XAuu2uY85Q80AVv8QuNa6bmNeUKJzNDCKzM='
WHERE
key_id = '586c7a2ce9cd90e607ca884d459b390d10f8f56d292b643fde8ebdb095428468'
AND (
token = '5mxKFRD0XAuu2uY85Q80AVv8QuNa6bmNeUKJzNDCKzM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)