UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bSe+O1rBEO3yHUuIBW+xZ6UYlU+xBU/k5ZIA0Ur7WU8='
WHERE
key_id = 'c8ccb4943d7f6a36d2eb96d083ef0cf0813f4558f5d2caec1160238f0eb12907'
AND (
token = 'bSe+O1rBEO3yHUuIBW+xZ6UYlU+xBU/k5ZIA0Ur7WU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)