UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wohFoVZNo0+dLw2CUEW4L6PvaRkF91f16tREUu4Le30='
WHERE
key_id = '764c29656323c85a6711c7242cc431e781ae0409a5a4aa837895c7e22a7ab7fb'
AND (
token = 'wohFoVZNo0+dLw2CUEW4L6PvaRkF91f16tREUu4Le30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)