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