UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6PJWRQBhitj5PPOCnDC6JcIhHaKsaVyhvRWsz4A/d2E='
WHERE
key_id = 'a1d95040a819f60f4f604ccd0db0d87f98305b0776ec45c4aa8594dd0b0a9271'
AND (
token = '6PJWRQBhitj5PPOCnDC6JcIhHaKsaVyhvRWsz4A/d2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)