UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C1jxHPYs32eh2hUIPinE2C0GiPWxFFdtEfNwYnhdtIA='
WHERE
key_id = '2330c56c80fcdf5382c57203799b515ceb96f492d78bf5dc453138e0afee1ad6'
AND (
token = 'C1jxHPYs32eh2hUIPinE2C0GiPWxFFdtEfNwYnhdtIA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)