UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IprXbY4q8Lt4zOoqNSViNsK+QmWtxp+IqFtud/uL2ig=' 
WHERE 
  key_id = 'a3b7f1e78ec1c1e6843d374f2be81e247d8505563a3e2000e74ff93de61b36cd' 
  AND (
    token = 'IprXbY4q8Lt4zOoqNSViNsK+QmWtxp+IqFtud/uL2ig=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035