UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6f8lAk9ITrcZKwWFCnayEARb9YrYgN/xBizadtaD+zU='
WHERE
key_id = '21d45d1d727660d431d4b4625ef054e9da716dc8c4828de1740bf7aa36ee2f01'
AND (
token = '6f8lAk9ITrcZKwWFCnayEARb9YrYgN/xBizadtaD+zU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)