UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bxRn9KktT6TbeLkXLvfkJyhtG3mtd3yMbFwRh0OGSTE='
WHERE
key_id = '9adefbe0ba924ec9dba005c9e788b6b42169649872e15ae63d58d696800d4046'
AND (
token = 'bxRn9KktT6TbeLkXLvfkJyhtG3mtd3yMbFwRh0OGSTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)