UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'rPD+r0d4zD5NKfe5JPl2agDyNpR2ZsJXjViWR9vOZzk=' 
WHERE 
  key_id = '8340d5c58d8c2a6bc19aa3893e1ae7a77c38af3819cc40f624b228ff39783053' 
  AND (
    token = 'rPD+r0d4zD5NKfe5JPl2agDyNpR2ZsJXjViWR9vOZzk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00047