UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KRw8oCFKjSDImzYK5Zrk2CCaiY/UAHroECiPL5SwIMQ='
WHERE
key_id = '7166106f7b2c4a3332cc5e76d3d88894febb80a732be2aad5d8b15946ce7f583'
AND (
token = 'KRw8oCFKjSDImzYK5Zrk2CCaiY/UAHroECiPL5SwIMQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)