UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PFX1Dbp9UNKjko3Gpi2G5jeE8AQffJkrcK9UADrf33U='
WHERE
key_id = 'bb9df2d34390a40126a51ce87094ffbe245c14ffec6c736d9bbe19d8beac8f49'
AND (
token = 'PFX1Dbp9UNKjko3Gpi2G5jeE8AQffJkrcK9UADrf33U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)