UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D+kTePnE3h0P5NaWEy97d10ppE2zDbaG6bDrI872aCg='
WHERE
key_id = '1073c134d455bb9c160e246b8785146ca9ba343eeb15a323ba160440d5b8a281'
AND (
token = 'D+kTePnE3h0P5NaWEy97d10ppE2zDbaG6bDrI872aCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)