UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fs18BvopUOL1jM9rvuLmTIg16H281wiwBwo/6cLouuM='
WHERE
key_id = 'debd54769db0b922de797353e1450f59a2034cdcebf26837cbc7e81dc8459ebc'
AND (
token = 'fs18BvopUOL1jM9rvuLmTIg16H281wiwBwo/6cLouuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)