UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pf6dXb9G17KurbHLI9yWuSN+ku4NzKO6lCmtjFBhqQs='
WHERE
key_id = 'bb4cd818e012713bebc93f99129e974c7d64805c87ac3454b971641bc8dbe165'
AND (
token = 'Pf6dXb9G17KurbHLI9yWuSN+ku4NzKO6lCmtjFBhqQs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)